/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package converter.core.db.entity;

import java.io.Serializable;
import java.math.BigInteger;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 *
 * @author Snark
 */
@Entity
@Table(name = "SYS_FIELDS")
@NamedQueries({
    @NamedQuery(name = "SysFields.findAll", query = "SELECT s FROM SysFields s"),
    @NamedQuery(name = "SysFields.findBySysFldorder", query = "SELECT s FROM SysFields s WHERE s.sysFldorder = :sysFldorder"),
    @NamedQuery(name = "SysFields.findBySysGuid", query = "SELECT s FROM SysFields s WHERE s.sysGuid = :sysGuid"),
    @NamedQuery(name = "SysFields.findBySysState", query = "SELECT s FROM SysFields s WHERE s.sysState = :sysState"),
    @NamedQuery(name = "SysFields.findBySysRev", query = "SELECT s FROM SysFields s WHERE s.sysRev = :sysRev"),
    @NamedQuery(name = "SysFields.findBySysCreated", query = "SELECT s FROM SysFields s WHERE s.sysCreated = :sysCreated"),
    @NamedQuery(name = "SysFields.findBySysUpdated", query = "SELECT s FROM SysFields s WHERE s.sysUpdated = :sysUpdated"),
    @NamedQuery(name = "SysFields.findBySysCreator", query = "SELECT s FROM SysFields s WHERE s.sysCreator = :sysCreator"),
    @NamedQuery(name = "SysFields.findBySysUser", query = "SELECT s FROM SysFields s WHERE s.sysUser = :sysUser"),
    @NamedQuery(name = "SysFields.findBySysGuidfk", query = "SELECT s FROM SysFields s WHERE s.sysGuidfk = :sysGuidfk"),
    @NamedQuery(name = "SysFields.findBySysParentguid", query = "SELECT s FROM SysFields s WHERE s.sysParentguid = :sysParentguid"),
    @NamedQuery(name = "SysFields.findByName", query = "SELECT s FROM SysFields s WHERE s.name = :name"),
    @NamedQuery(name = "SysFields.findByAlias", query = "SELECT s FROM SysFields s WHERE s.alias = :alias"),
    @NamedQuery(name = "SysFields.findByDescription", query = "SELECT s FROM SysFields s WHERE s.description = :description"),
    @NamedQuery(name = "SysFields.findByType", query = "SELECT s FROM SysFields s WHERE s.type = :type"),
    @NamedQuery(name = "SysFields.findByLength", query = "SELECT s FROM SysFields s WHERE s.length = :length"),
    @NamedQuery(name = "SysFields.findByPrecision", query = "SELECT s FROM SysFields s WHERE s.precision = :precision"),
    @NamedQuery(name = "SysFields.findByVisible", query = "SELECT s FROM SysFields s WHERE s.visible = :visible"),
    @NamedQuery(name = "SysFields.findByListstyle", query = "SELECT s FROM SysFields s WHERE s.liststyle = :liststyle"),
    @NamedQuery(name = "SysFields.findByIsunique", query = "SELECT s FROM SysFields s WHERE s.isunique = :isunique"),
    @NamedQuery(name = "SysFields.findByIsnotnull", query = "SELECT s FROM SysFields s WHERE s.isnotnull = :isnotnull"),
    @NamedQuery(name = "SysFields.findByLookupsource", query = "SELECT s FROM SysFields s WHERE s.lookupsource = :lookupsource"),
    @NamedQuery(name = "SysFields.findByLookupfield", query = "SELECT s FROM SysFields s WHERE s.lookupfield = :lookupfield"),
    @NamedQuery(name = "SysFields.findByLookupdisplay", query = "SELECT s FROM SysFields s WHERE s.lookupdisplay = :lookupdisplay"),
    @NamedQuery(name = "SysFields.findByLookuporder", query = "SELECT s FROM SysFields s WHERE s.lookuporder = :lookuporder"),
    @NamedQuery(name = "SysFields.findByLookupasform", query = "SELECT s FROM SysFields s WHERE s.lookupasform = :lookupasform"),
    @NamedQuery(name = "SysFields.findByFilter", query = "SELECT s FROM SysFields s WHERE s.filter = :filter"),
    @NamedQuery(name = "SysFields.findByCharcase", query = "SELECT s FROM SysFields s WHERE s.charcase = :charcase"),
    @NamedQuery(name = "SysFields.findByPassword", query = "SELECT s FROM SysFields s WHERE s.password = :password"),
    @NamedQuery(name = "SysFields.findByAutofill", query = "SELECT s FROM SysFields s WHERE s.autofill = :autofill"),
    @NamedQuery(name = "SysFields.findByEmptyvalue", query = "SELECT s FROM SysFields s WHERE s.emptyvalue = :emptyvalue"),
    @NamedQuery(name = "SysFields.findByPrefix", query = "SELECT s FROM SysFields s WHERE s.prefix = :prefix"),
    @NamedQuery(name = "SysFields.findByReadonly", query = "SELECT s FROM SysFields s WHERE s.readonly = :readonly"),
    @NamedQuery(name = "SysFields.findByNotexportable", query = "SELECT s FROM SysFields s WHERE s.notexportable = :notexportable"),
    @NamedQuery(name = "SysFields.findByDefvalue", query = "SELECT s FROM SysFields s WHERE s.defvalue = :defvalue"),
    @NamedQuery(name = "SysFields.findByRegexp", query = "SELECT s FROM SysFields s WHERE s.regexp = :regexp"),
    @NamedQuery(name = "SysFields.findByInputmask", query = "SELECT s FROM SysFields s WHERE s.inputmask = :inputmask"),
    @NamedQuery(name = "SysFields.findByDisplayformat", query = "SELECT s FROM SysFields s WHERE s.displayformat = :displayformat"),
    @NamedQuery(name = "SysFields.findByUsethousandseparator", query = "SELECT s FROM SysFields s WHERE s.usethousandseparator = :usethousandseparator"),
    @NamedQuery(name = "SysFields.findByRadioorigin", query = "SELECT s FROM SysFields s WHERE s.radioorigin = :radioorigin"),
    @NamedQuery(name = "SysFields.findByRadiocolumns", query = "SELECT s FROM SysFields s WHERE s.radiocolumns = :radiocolumns"),
    @NamedQuery(name = "SysFields.findByCaneditinchooser", query = "SELECT s FROM SysFields s WHERE s.caneditinchooser = :caneditinchooser"),
    @NamedQuery(name = "SysFields.findByLookupfieldslist", query = "SELECT s FROM SysFields s WHERE s.lookupfieldslist = :lookupfieldslist")})
public class SysFields implements Serializable {
    private static final long serialVersionUID = 1L;
    @Column(name = "SYS_FLDORDER")
    private Integer sysFldorder;
    @Id
    @Basic(optional = false)
    @Column(name = "SYS_GUID")
    private String sysGuid;
    @Column(name = "SYS_STATE")
    private Integer sysState;
    @Column(name = "SYS_REV")
    private BigInteger sysRev;
    @Column(name = "SYS_CREATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysCreated;
    @Column(name = "SYS_UPDATED")
    @Temporal(TemporalType.TIMESTAMP)
    private Date sysUpdated;
    @Column(name = "SYS_CREATOR")
    private String sysCreator;
    @Column(name = "SYS_USER")
    private String sysUser;
    @Column(name = "SYS_GUIDFK")
    private String sysGuidfk;
    @Column(name = "SYS_PARENTGUID")
    private String sysParentguid;
    @Column(name = "NAME")
    private String name;
    @Column(name = "ALIAS")
    private String alias;
    @Column(name = "DESCRIPTION")
    private String description;
    @Lob
    @Column(name = "COMMENT")
    private String comment;
    @Column(name = "TYPE")
    private String type;
    @Column(name = "LENGTH")
    private Short length;
    @Column(name = "PRECISION")
    private Short precision;
    @Column(name = "VISIBLE")
    private String visible;
    @Lob
    @Column(name = "LISTSOURCE")
    private String listsource;
    @Lob
    @Column(name = "LISTKEYS")
    private String listkeys;
    @Column(name = "LISTSTYLE")
    private String liststyle;
    @Column(name = "ISUNIQUE")
    private Integer isunique;
    @Column(name = "ISNOTNULL")
    private String isnotnull;
    @Column(name = "LOOKUPSOURCE")
    private String lookupsource;
    @Lob
    @Column(name = "LOOKUPQUERY")
    private String lookupquery;
    @Column(name = "LOOKUPFIELD")
    private String lookupfield;
    @Column(name = "LOOKUPDISPLAY")
    private String lookupdisplay;
    @Column(name = "LOOKUPORDER")
    private String lookuporder;
    @Column(name = "LOOKUPASFORM")
    private Integer lookupasform;
    @Lob
    @Column(name = "LOOKUPFILTER")
    private String lookupfilter;
    @Column(name = "FILTER")
    private String filter;
    @Lob
    @Column(name = "CALCSCRIPT")
    private String calcscript;
    @Column(name = "CHARCASE")
    private String charcase;
    @Column(name = "PASSWORD")
    private Integer password;
    @Column(name = "AUTOFILL")
    private Integer autofill;
    @Column(name = "EMPTYVALUE")
    private String emptyvalue;
    @Column(name = "PREFIX")
    private String prefix;
    @Column(name = "READONLY")
    private Integer readonly;
    @Column(name = "NOTEXPORTABLE")
    private Integer notexportable;
    @Lob
    @Column(name = "TEMPLATE")
    private String template;
    @Column(name = "DEFVALUE")
    private String defvalue;
    @Column(name = "REGEXP")
    private String regexp;
    @Column(name = "INPUTMASK")
    private String inputmask;
    @Lob
    @Column(name = "CAPTIONSCRIPT")
    private String captionscript;
    @Column(name = "DISPLAYFORMAT")
    private String displayformat;
    @Column(name = "USETHOUSANDSEPARATOR")
    private Integer usethousandseparator;
    @Column(name = "RADIOORIGIN")
    private String radioorigin;
    @Column(name = "RADIOCOLUMNS")
    private Integer radiocolumns;
    @Column(name = "CANEDITINCHOOSER")
    private Integer caneditinchooser;
    @Lob
    @Column(name = "WP_TEMPLATE")
    private String wpTemplate;
    @Lob
    @Column(name = "SELECTABLE")
    private String selectable;
    @Column(name = "LOOKUPFIELDSLIST")
    private String lookupfieldslist;

    public SysFields() {
    }

    public SysFields(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysFldorder() {
        return sysFldorder;
    }

    public void setSysFldorder(Integer sysFldorder) {
        this.sysFldorder = sysFldorder;
    }

    public String getSysGuid() {
        return sysGuid;
    }

    public void setSysGuid(String sysGuid) {
        this.sysGuid = sysGuid;
    }

    public Integer getSysState() {
        return sysState;
    }

    public void setSysState(Integer sysState) {
        this.sysState = sysState;
    }

    public BigInteger getSysRev() {
        return sysRev;
    }

    public void setSysRev(BigInteger sysRev) {
        this.sysRev = sysRev;
    }

    public Date getSysCreated() {
        return sysCreated;
    }

    public void setSysCreated(Date sysCreated) {
        this.sysCreated = sysCreated;
    }

    public Date getSysUpdated() {
        return sysUpdated;
    }

    public void setSysUpdated(Date sysUpdated) {
        this.sysUpdated = sysUpdated;
    }

    public String getSysCreator() {
        return sysCreator;
    }

    public void setSysCreator(String sysCreator) {
        this.sysCreator = sysCreator;
    }

    public String getSysUser() {
        return sysUser;
    }

    public void setSysUser(String sysUser) {
        this.sysUser = sysUser;
    }

    public String getSysGuidfk() {
        return sysGuidfk;
    }

    public void setSysGuidfk(String sysGuidfk) {
        this.sysGuidfk = sysGuidfk;
    }

    public String getSysParentguid() {
        return sysParentguid;
    }

    public void setSysParentguid(String sysParentguid) {
        this.sysParentguid = sysParentguid;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getAlias() {
        return alias;
    }

    public void setAlias(String alias) {
        this.alias = alias;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getComment() {
        return comment;
    }

    public void setComment(String comment) {
        this.comment = comment;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public Short getLength() {
        return length;
    }

    public void setLength(Short length) {
        this.length = length;
    }

    public Short getPrecision() {
        return precision;
    }

    public void setPrecision(Short precision) {
        this.precision = precision;
    }

    public String getVisible() {
        return visible;
    }

    public void setVisible(String visible) {
        this.visible = visible;
    }

    public String getListsource() {
        return listsource;
    }

    public void setListsource(String listsource) {
        this.listsource = listsource;
    }

    public String getListkeys() {
        return listkeys;
    }

    public void setListkeys(String listkeys) {
        this.listkeys = listkeys;
    }

    public String getListstyle() {
        return liststyle;
    }

    public void setListstyle(String liststyle) {
        this.liststyle = liststyle;
    }

    public Integer getIsunique() {
        return isunique;
    }

    public void setIsunique(Integer isunique) {
        this.isunique = isunique;
    }

    public String getIsnotnull() {
        return isnotnull;
    }

    public void setIsnotnull(String isnotnull) {
        this.isnotnull = isnotnull;
    }

    public String getLookupsource() {
        return lookupsource;
    }

    public void setLookupsource(String lookupsource) {
        this.lookupsource = lookupsource;
    }

    public String getLookupquery() {
        return lookupquery;
    }

    public void setLookupquery(String lookupquery) {
        this.lookupquery = lookupquery;
    }

    public String getLookupfield() {
        return lookupfield;
    }

    public void setLookupfield(String lookupfield) {
        this.lookupfield = lookupfield;
    }

    public String getLookupdisplay() {
        return lookupdisplay;
    }

    public void setLookupdisplay(String lookupdisplay) {
        this.lookupdisplay = lookupdisplay;
    }

    public String getLookuporder() {
        return lookuporder;
    }

    public void setLookuporder(String lookuporder) {
        this.lookuporder = lookuporder;
    }

    public Integer getLookupasform() {
        return lookupasform;
    }

    public void setLookupasform(Integer lookupasform) {
        this.lookupasform = lookupasform;
    }

    public String getLookupfilter() {
        return lookupfilter;
    }

    public void setLookupfilter(String lookupfilter) {
        this.lookupfilter = lookupfilter;
    }

    public String getFilter() {
        return filter;
    }

    public void setFilter(String filter) {
        this.filter = filter;
    }

    public String getCalcscript() {
        return calcscript;
    }

    public void setCalcscript(String calcscript) {
        this.calcscript = calcscript;
    }

    public String getCharcase() {
        return charcase;
    }

    public void setCharcase(String charcase) {
        this.charcase = charcase;
    }

    public Integer getPassword() {
        return password;
    }

    public void setPassword(Integer password) {
        this.password = password;
    }

    public Integer getAutofill() {
        return autofill;
    }

    public void setAutofill(Integer autofill) {
        this.autofill = autofill;
    }

    public String getEmptyvalue() {
        return emptyvalue;
    }

    public void setEmptyvalue(String emptyvalue) {
        this.emptyvalue = emptyvalue;
    }

    public String getPrefix() {
        return prefix;
    }

    public void setPrefix(String prefix) {
        this.prefix = prefix;
    }

    public Integer getReadonly() {
        return readonly;
    }

    public void setReadonly(Integer readonly) {
        this.readonly = readonly;
    }

    public Integer getNotexportable() {
        return notexportable;
    }

    public void setNotexportable(Integer notexportable) {
        this.notexportable = notexportable;
    }

    public String getTemplate() {
        return template;
    }

    public void setTemplate(String template) {
        this.template = template;
    }

    public String getDefvalue() {
        return defvalue;
    }

    public void setDefvalue(String defvalue) {
        this.defvalue = defvalue;
    }

    public String getRegexp() {
        return regexp;
    }

    public void setRegexp(String regexp) {
        this.regexp = regexp;
    }

    public String getInputmask() {
        return inputmask;
    }

    public void setInputmask(String inputmask) {
        this.inputmask = inputmask;
    }

    public String getCaptionscript() {
        return captionscript;
    }

    public void setCaptionscript(String captionscript) {
        this.captionscript = captionscript;
    }

    public String getDisplayformat() {
        return displayformat;
    }

    public void setDisplayformat(String displayformat) {
        this.displayformat = displayformat;
    }

    public Integer getUsethousandseparator() {
        return usethousandseparator;
    }

    public void setUsethousandseparator(Integer usethousandseparator) {
        this.usethousandseparator = usethousandseparator;
    }

    public String getRadioorigin() {
        return radioorigin;
    }

    public void setRadioorigin(String radioorigin) {
        this.radioorigin = radioorigin;
    }

    public Integer getRadiocolumns() {
        return radiocolumns;
    }

    public void setRadiocolumns(Integer radiocolumns) {
        this.radiocolumns = radiocolumns;
    }

    public Integer getCaneditinchooser() {
        return caneditinchooser;
    }

    public void setCaneditinchooser(Integer caneditinchooser) {
        this.caneditinchooser = caneditinchooser;
    }

    public String getWpTemplate() {
        return wpTemplate;
    }

    public void setWpTemplate(String wpTemplate) {
        this.wpTemplate = wpTemplate;
    }

    public String getSelectable() {
        return selectable;
    }

    public void setSelectable(String selectable) {
        this.selectable = selectable;
    }

    public String getLookupfieldslist() {
        return lookupfieldslist;
    }

    public void setLookupfieldslist(String lookupfieldslist) {
        this.lookupfieldslist = lookupfieldslist;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (sysGuid != null ? sysGuid.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof SysFields)) {
            return false;
        }
        SysFields other = (SysFields) object;
        if ((this.sysGuid == null && other.sysGuid != null) || (this.sysGuid != null && !this.sysGuid.equals(other.sysGuid))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "javaapplication1.entity.SysFields[ sysGuid=" + sysGuid + " ]";
    }
    
}
